﻿<h3 class="yellow f14">Liste des Conferences</h3>






<?php

$this->load->database();

$confList = $this->db->query('SELECT * from conference');

foreach($confList->result() as $infos)
{
	//print_r($infos);
	//stdClass Object ( [IDENTIFIANT] => 2 [NOM] => BIG ROOM LTD 5 [DATEDEBUT] => 2012-03-31 [DUREE] => 7 [DATEFINSOUMISSION] => 2012-03-13 00:00:00 )


	$query = $this->db->query("SELECT libelle from theme
								join contenir on contenir.identifiant_1 = theme.identifiant
							 	join conference on conference.identifiant = contenir.identifiant
								where conference.identifiant = '".$infos->IDENTIFIANT."'");


	echo '<div id="conference">';
	echo '<h4>';
	echo '<a
			href="'.site_url('conferences/afficherConf') . '/' . $infos->IDENTIFIANT.'">'.$infos->NOM.
		'</a>';
	echo '</h4><div id="themes">Themes : <br /><ul>';

	foreach ($query->result() as $row)
	{
		echo '<li>'.$row->libelle.'</li><br/>';
	}

	echo '</ul>
</div>
</div>';
}

?>


